<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="../styles/estilo1.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?php $ruta_raiz = "..";
	include("$ruta_raiz/adodb/adodb.inc.php");
	include("$ruta_raiz/config.php");
	
	$db = NewADOConnection('mysql');
	//$db->debug = true;
  	$db->Connect("$host", "$root_user", "$passwd", "$dbname");
	?>
    <? 
	$rs = $db->Execute("SELECT asis_fecha from asistencia where asis_evento = $evento group by asis_fecha;");
	
	?>
    <div align="center" class="titulo">Listado para certificados</div>
    <form action= "./certpendientes.php" method="post" name="form1">
    	<table width="100%" border="0">
  			<tr>
    			<?     
				$i = 0;
				while (!$rs->EOF) {
					$i++;
	
				?>
    			<td class="body">D&iacute;a <? echo $i ?> (<? echo $rs->fields[0]; ?>) 
                <input name="fecha<? echo $i;?>check" type="checkbox" />
                <input name="fecha<? echo $i;?>" type="hidden" value="<? echo $rs->fields[0]; ?>" />
                </td>
    				<?
					if (($i % 5) == 0){
				?>
    		</tr>
    		<tr>
				<?
    			}
				$rs->MoveNext();
				
			}
    		?>
            <input name="dias" type="hidden" value="<? echo  $i;?>" />
    		</tr>
            <tr>
            	<td colspan="5" align="center" class="body">
                Cualquier d&iacute;a
                <input type="checkbox" name="fechaxcheck" />
                
                </td>
            </tr>
		</table>
        <div align="center"><input name="consultar"  value="Consultar" type="submit" /></div>
    </form>
    
</body>
</html>
